ALTER VIEW [dbo].[View_FW_AdvanceSet]
AS
SELECT
         fas.AdvanceSetGUID,
         fas.AdvanceSetName,
         fas.AdvancePage,
         fas.AdvanceSetJson,
         fas.UserGUID,
         fas.TenantId,
         fas.IsDeleted,
         fas.CreateTime,
         fas.CreateGUID,
         fas.CreatedName,
         fas.ModifiedTime,
         fas.ModifiedGUID,
         fas.ModifiedName,
         fas.ApproveState,
         fas.ApproveGUID,
         fas.ApproveTime,
         fas.BuUnitGUID,
		 fas.AdvanceSetType,
		 fu.UserName
FROM dbo.FW_AdvanceSet fas
LEFT JOIN dbo.FW_User fu ON fas.UserGUID=fu.UserGUID
